Author: Sally Oberst
Last saved by: Tamzin Anderson

Appendix I.
General data
•	name of the locality (varchar type)
•	land registry name (varchar type)
•	name of the quarry (varchar type)
•	state of the quarry – selection between productive and abandoned quarry, and between shelf and pit quarry (enum type)
•	map – selection of map scale (enum type)
•	map number (varchar type)
•	co-ordinates – given in degrees, minutes and seconds, which are subsequently converted into degrees (real numbers are entered, type float). For printout, these are compiled as degrees, minutes, and seconds.

When the setting is incorrect, for example setting minutes out of the range 0 - 60, the number is recalculated, and any follow-up printout will be corrected.

Petrographic description:
macroscopic description
•	type of the rock (varchar type)
•	colour (varchar type)
•	macrostructure (varchar type)
microscopic description
•	main minerals (varchar type)
•	minor minerals (varchar type)
•	accessory minerals (varchar type)
•	secondary minerals (varchar type)
•	opaque minerals (varchar type)
•	bioclasts (varchar type)
•	cement (varchar type)
•	matrix (varchar type)
•	pores (varchar type)
•	microstructure (varchar type)
X-ray diffraction data
•	X-ray diffraction (e.g. of insoluble residuum for sedimentary rocks containing calcite) – proportional representation of particular mineral phases (varchar type)
•	X-ray diffraction graph – allows inserting one graph in *.jpg or *.gif format. The size of this graph may not surpass the value which is listed in file funkce.php.
Petrographic classification of the rock, according to the appropriate system (varchar type)
Chemical composition
•	main elements – in the primary window we set number of analyses (maximal number is set at 255), after pressing of “Insert results of analyses” button a new window appears. It contains a table, where columns represent particular analyses. Numbers set as a float type. Other chemical analyses have similar means to set the results.
•	minor and trace elements
•	isotopes – values of δ^13C (PDP), δ^18O (PDP), δ^18O (SMOW), and/or ^87Sr/^86Sr
•	carbon/sulphur analysis
•	insoluble residuum

Some analytical data may be under the detection limits of an instrument. In such a case, the value is set with the symbol “<”. This setting requires a new column in the database for each analysis which would produce great undetected weighting of the system. The “<” problem has therefore been solved by use of the following trick. Due to the fact that data are set as a float type, they can also have negative values. During the transfer of data into the database the symbol “<” is replaced by the symbol “-“, and so it is possible to work with the data as if it were a number.
At the setting of any numerical data it is also necessary to have in mind (for non-English users), that MySQL uses the English notation system for decimal points (Czech uses a comma instead of the dot). If the real number is entered in the Czech format (for example: 10,37) this will be interpreted by the system as two independent numbers (i.e. 10 and 37).

Technological properties – after inserting number of analyses, the following properties can be filled:
•	specific density [g/cm^3]
•	bulk density [g/cm^3]
•	water absorption [wt.%]
•	porosity [vol.%]
•	magnetic susceptibility [10^-6 SI units]
•	flexural strength of dry samples [MPa]
•	flexural strength of water saturated samples [MPa] 
•	uniaxial compressive strength of dry samples [MPa]
•	uniaxial compressive strength of water saturated samples [MPa]
•	uniaxial compressive strength after certain number of freeze/thaw cycles [MPa]
•	freeze/thaw resistance [vol.%]
•	abrasion resistance (Böhme or Amsler) [cm^3/cm^2]
•	polishing ability (varchar type)
•	variety of colour (varchar type)
•	resistance to weathering (varchar type)
Architectural and sculptural workability – particular items are real numbers; it is also possible to set values as a range (with a dash, for example 2-3.5). The system can resolve if the first number is higher than the second one. The system will operate only with the first number in the opposite case.
•	hardness 
•	softness 
•	friability 
•	cleavability 
•	abrasion 
•	dustiness 
•	tendency to keep shape (concave)
•	tendency to keep shape (convex) 
•	tendency to keep shape (edge) 
•	possible use for sculptural purposes
•	possible use for architectural purposes
Parameters of the deposit
•	geological position (varchar type)
•	age (varchar type)
•	level of geological exploration (textarea type)
•	surrounding quarries (varchar type)
•	underlying units (varchar type)
•	thickness of the deposit (varchar type)
•	overburden (varchar type)
•	cleavage (varchar type)
•	fracture orientation graph – is it possible to set one graph in *.jpg or *.gif format. Size of file may not surpass the value, which is listed in file funkce.php.
•	plane of division pattern (varchar type)
•	block size (varchar type)
•	variability of raw material (varchar type)
•	genesis of quarry (varchar type)
•	type of quarry (varchar type)
•	hydrogeological situation (varchar type)
•	conflict of interests (varchar type)
•	production efficiency (varchar type)
Exploitation and historical utilisation
•	exploitation period (varchar type)
•	documented mode of utilisation  (varchar type)
•	buildings and monuments (textarea type)
•	documented denomination used in the past (textarea type)
Notes: area for recording of other unclassified data about the rock (textarea type)
Next Figures: is it possible to add as many as 255 files. Various *.jpg or *.gif files are restricted by size, which is listed in the file funkce.php. 
References: this record is set separately as a textarea type. After pressing the “Select” button, a new window will open. The appropriate citation can be selected from the existing list of references. The system controls the repeated setting of an identical citation on the selected rock. The total number of citations is displayed in the mainsheet.